
Use SuperMarketManagement
go
declare @text nvarchar(100)
declare @sql nvarchar(100)
while (select COUNT(name) from sys.procedures)>0
	begin
		set @text =(select top(1)name from sys.procedures)
		set @sql =N'drop proc '+@text
		exec sp_executesql @sql
	end

--go
--SELECT * FROM sys.all_objects
--WHERE ([type] = 'IF')
--ORDER BY [name];







